Writing Advanced Queries Using SQL
The two-day course aims to acquaint students with SQL. Its content is a description of advanced language syntax, definition of data structures, queries, and data manipulation. It follows the course SQL language.
Code
SQL-Jazyk 2
Course length
3
days
(8:30 – 16:00)
Form
In our classroom or online
Dates
This course is intended for
- Database administrators, developers, IT architects
- Users who will use SQL to query, report and analyze
Syllabus
- Review and Extension of SQL1 Content
- Subqueries
- Table Expressions – Derived Tables, CTE, TVF, APPLY
- Pivot
- Views
- Scalar Functions and Multi-statement TVFs
- Stored Procedures
- Dynamic SQL
- Transactions and Query Optimization
Students will be able to
- Create and use advanced queries in SQL and manipulate with data.
- Define and work with advanced database objects.
Course requirements
- Refresh, master, and learn new SQL knowledge
Hardware
Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.
Literature
All participants will get internal materials.
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.
Similar courses
Take a look at some similar courses from our wide range.
Fundamentals of SQL Language for Users SQL-Jazyk 0
Installing, Administering and Maintaining a Microsoft SQL Server and Database Infrastructure DB-ADM
Writing Queries Using SQL SQL-Jazyk 1
Need some advice?
Do not hesitate to contact us. We are at your disposal and will be happy to help you.
Why OKškolení?
What are the main advantages of our training centre?
36+ years in business
We have been on the market for more than 36 years and have a wealth of experience in this field.
We are a training center with a rich history and tradition.
Experienced tutors
The basis of any quality education is good and experienced lecturers and this is something that we at OKškolení take particular pride in. Our top lecturers are waiting for you.
Modern classrooms
All classrooms are spacious, air-conditioned, barrier-free and equipped with high-standard computers, with Wi-Fi connection.
Bonus program
Protect your investments into education, loyalty program, advantageous offers, refreshments, grants...
Contact us
Do not hesitate to contact us with any questions you may have.
Do you need to know more about us or would you prefer to contact us using the form?
